Prerequisites

The following section describes the prerequisites for working with Qlik Replicate and an AWS Aurora Cloud for PostgreSQL database source.

Download PostgreSQL 13 ODBC driver, and client programs and libraries.

• Example PostgreSQL ODBC file name: postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm
• PostgreSQL client programs and libraries file name: postgresql13-13.8-1PGDG.rhel<version>.x86_64.rpm

Then, open a shell prompt and do the following:

1. Stop the Replicate service:

   ./areplicate stop

2. Optionally, confirm that the service has stopped:

   ./areplicate status

3. Install PostgreSQL 13 client programs and libraries.

4. Install the ODBC driver for PostgreSQL 13.

5. Change the working directory to <Replicate-Install-Dir>/bin.

6. Copy the driver location to the site_arep_login.sh file:

   echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-13/lib" >> site_arep_login.sh

   This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.

7. Optionally, confirm that the driver location was copied:

   cat site_arep_login.sh

8. Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:

   [PostgreSQL Unicode(x64)]

   Description = PostgreSQL ODBC driver

   Driver = /usr/pgsql-13/lib/psqlodbc.so

   Setup = /usr/pgsql-13/lib/psqlodbcw.so

   UsageCount = 1

9. Start the Replicate service:

   ./areplicate start

10. Optionally, confirm that the service has started:

    ./areplicate status

• When the Apply Changes task option is enabled, the user specified in the PostgreSQL source database’s General tab must be granted super-user permissions.